from utils import readExcelToOneArray, setZFListByCoord

# excel路径
excel_path = r'.\excels\right.xlsx'

try:
    # raise SystemExit
    # 外层循环遍历每个分组
    for group_index, group in enumerate(readExcelToOneArray(excel_path)):
        s = ''
        waitTime = 0.2
        # 循环遍历分组内的每个字典（每行数据）
        s = str(group['代码'])[2:]
        up = str(group['涨幅超'])
        entrust = str(group['委托价'])
        setZFListByCoord(s, up, entrust, [group], waitTime)

        print()  # 打印一个空行作为组之间的分隔3.5
except KeyboardInterrupt:
    print("\n检测到用户中断（Ctrl+C），程序已终止。")